﻿CREATE TABLE [dbo].[tblMonitor_PerfmonHourlySummary]
(
	date_inserted datetime NOT NULL,
	buffer_cache_hit_ratio_AVG float NULL,
	buffer_cache_hit_ratio_STDEVP float NULL,
	page_life_expectancy_AVG int NULL,
	page_life_expectancy_STDEVP int NULL,
	logins_per_sec_AVG float NULL,
	logins_per_sec_STDEVP float NULL,
	logouts_per_sec_AVG float NULL,
	logouts_per_sec_STDEVP float NULL,
	user_connections_AVG int NULL,
	user_connections_STDEVP int NULL,
	optimizer_memory_KB int NULL,
	sql_cache_memory_KB int NULL,
	target_server_memory_KB int NULL,
	total_server_memory_KB int NULL,
	sql_compilations_per_sec_AVG float NULL,
	sql_compilations_per_sec_STDEVP float NULL,
	sql_recompilations_per_sec_AVG float NULL,
	sql_recompilations_per_sec_STDEVP float NULL,
	batch_requests_per_sec_AVG float NULL,
	batch_requests_per_sec_STDEVP float NULL,
	number_of_deadlocks_per_sec_AVG float NULL,
	number_of_deadlocks_per_sec_STDEVP float NULL,
	average_wait_time_ms_AVG float NULL,
	average_wait_time_ms_STDEVP float NULL,
	lock_waits_per_sec_AVG float NULL,
	lock_waits_per_sec_STDEVP float NULL,
	lock_wait_time_ms_AVG float NULL,
	lock_wait_time_ms_STDEVP float NULL,
	full_scans_per_sec_AVG float NULL,
	full_scans_per_sec_STDEVP float NULL,
	lazy_writes_per_sec_AVG float NULL,
	lazy_writes_per_sec_STDEVP float NULL,
	page_reads_per_sec_AVG float NULL,
	page_reads_per_sec_STDEVP float NULL,
	page_writes_per_sec_AVG float NULL,
	page_writes_per_sec_STDEVP float NULL,
	checkpoint_pages_per_sec_AVG float NULL,
	checkpoint_pages_per_sec_STDEVP float NULL,
	page_splits_per_sec_AVG float NULL,
	page_splits_per_sec_STDEVP float NULL,
	transactions_per_sec_AVG float NULL,
	transactions_per_sec_STDEVP float NULL,
	cpu_busy_AVG float NULL,
	cpu_busy_STDEVP float NULL,
	io_busy_AVG float NULL,
	io_busy_STDEVP float NULL,
	CONSTRAINT [PK_tblMonitor_PerfmonHourlySummary] PRIMARY KEY CLUSTERED ([date_inserted] ASC)
)